package com.cl.master.mapper;

import com.cl.master.domain.SewageStandard;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import java.util.Collection;
import java.util.List;
import java.util.Map;

/**
 * @Author xc
 * @Date 2023/4/26 15:40
 * @Version 1.0
 */
@Mapper
@Repository
// @Mapper
@Component
public interface SewageStandardMapper {

    /**
     * 查询所有公司的排污信息
     * @return Collection
     */
    Collection<SewageStandard> getAllInfo(int startPage);

    /**
     * 查询单个公司的所有排污信息
     * @param code
     * @return
     */
    Collection<SewageStandard> getInfoByCode(String code);

    /**
     * 添加公司的所有排污信息
     */
    void addAllInfo(SewageStandard sewageStandard);


    // @Select("SELECT company_code, outlet_code, pollutant_concentration, pollutant_discharge FROM sewagestandard")
    @Select("SELECT * FROM sewagestandard")
    List<Map<String, Object>> getEnterpriseData();


}

